/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 724

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 55 53 54 4f 4d 20 54 | 52 49 47 47 45 52 20 44 |CUSTOM T|RIGGER D|
|00000010| 45 46 41 55 4c 54 20 42 | 4f 44 59 00 63 72 65 61 |EFAULT B|ODY.crea|
|00000020| 74 65 20 74 72 69 67 67 | 65 72 20 25 54 72 69 67 |te trigg|er %Trig|
|00000030| 67 65 72 4e 61 6d 65 20 | 25 46 69 72 65 20 25 41 |gerName |%Fire %A|
|00000040| 63 74 69 6f 6e 20 6f 6e | 20 25 54 61 62 6c 65 4e |ction on| %TableN|
|00000050| 61 6d 65 0d 0a 25 49 66 | 28 25 3d 3d 28 25 41 63 |ame..%If|(%==(%Ac|
|00000060| 74 69 6f 6e 2c 55 50 44 | 41 54 45 29 29 20 7b 20 |tion,UPD|ATE)) { |
|00000070| 20 25 49 66 28 25 4e 6f | 74 28 25 52 65 66 43 6c | %If(%No|t(%RefCl|
|00000080| 61 75 73 65 29 29 20 7b | 52 65 66 65 72 65 6e 63 |ause)) {|Referenc|
|00000090| 69 6e 67 20 6f 6c 64 20 | 61 73 20 6f 6c 64 20 6e |ing old |as old n|
|000000a0| 65 77 20 61 73 20 6e 65 | 77 7d 20 25 45 6c 73 65 |ew as ne|w} %Else|
|000000b0| 20 7b 25 52 65 66 43 6c | 61 75 73 65 7d 0d 0a 28 | {%RefCl|ause}..(|
|000000c0| 65 78 65 63 75 74 65 20 | 69 6e 6c 69 6e 65 20 28 |execute |inline (|
|000000d0| 25 41 74 74 73 28 22 2c | 22 2c 2c 25 4f 6c 64 29 |%Atts(",|",,%Old)|
|000000e0| 2c 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |,..     |        |
|000000f0| 20 20 20 20 25 41 74 74 | 73 28 22 2c 22 2c 2c 25 |    %Att|s(",",,%|
|00000100| 4e 65 77 29 29 0d 0a 7d | 25 45 6c 73 65 20 7b 28 |New))..}|%Else {(|
|00000110| 65 78 65 63 75 74 65 20 | 69 6e 6c 69 6e 65 20 28 |execute |inline (|
|00000120| 25 41 74 74 73 28 22 2c | 22 2c 2c 29 29 0d 0a 7d |%Atts(",|",,))..}|
|00000130| 70 72 6f 63 65 64 75 72 | 65 20 70 25 31 41 63 74 |procedur|e p%1Act|
|00000140| 69 6f 6e 5f 25 31 35 54 | 61 62 6c 65 4e 61 6d 65 |ion_%15T|ableName|
|00000150| 20 73 74 61 74 69 63 0d | 0a 50 61 72 61 6d 65 74 | static.|.Paramet|
|00000160| 65 72 73 0d 0a 20 20 25 | 49 66 28 25 3d 3d 28 25 |ers..  %|If(%==(%|
|00000170| 41 63 74 69 6f 6e 2c 55 | 50 44 41 54 45 29 29 20 |Action,U|PDATE)) |
|00000180| 7b 20 20 25 46 6f 72 45 | 61 63 68 41 74 74 28 29 |{  %ForE|achAtt()|
|00000190| 20 7b 20 20 25 41 74 74 | 50 68 79 73 44 61 74 61 | {  %Att|PhysData|
|000001a0| 74 79 70 65 20 6f 25 31 | 37 41 74 74 46 69 65 6c |type o%1|7AttFiel|
|000001b0| 64 4e 61 6d 65 0d 0a 20 | 20 7d 0d 0a 20 20 25 46 |dName.. | }..  %F|
|000001c0| 6f 72 45 61 63 68 41 74 | 74 28 29 20 7b 20 20 25 |orEachAt|t() {  %|
|000001d0| 41 74 74 50 68 79 73 44 | 61 74 61 74 79 70 65 20 |AttPhysD|atatype |
|000001e0| 6e 25 31 37 41 74 74 46 | 69 65 6c 64 4e 61 6d 65 |n%17AttF|ieldName|
|000001f0| 0d 0a 20 20 7d 0d 0a 7d | 20 20 25 45 6c 73 65 20 |..  }..}|  %Else |
|00000200| 7b 20 20 25 46 6f 72 45 | 61 63 68 41 74 74 28 29 |{  %ForE|achAtt()|
|00000210| 20 7b 0d 0a 20 20 25 41 | 74 74 50 68 79 73 44 61 | {..  %A|ttPhysDa|
|00000220| 74 61 74 79 70 65 20 25 | 41 74 74 46 69 65 6c 64 |tatype %|AttField|
|00000230| 4e 61 6d 65 0d 0a 20 20 | 7d 0d 0a 7d 4c 6f 63 61 |Name..  |}..}Loca|
|00000240| 6c 20 56 61 72 69 61 62 | 6c 65 73 0d 0a 20 20 53 |l Variab|les..  S|
|00000250| 71 6c 20 48 61 6e 64 6c | 65 20 68 53 71 6c 0d 0a |ql Handl|e hSql..|
|00000260| 20 20 4e 75 6d 62 65 72 | 20 6e 75 6d 72 6f 77 73 |  Number| numrows|
|00000270| 0d 0a 41 63 74 69 6f 6e | 73 0d 0a 20 20 4f 6e 20 |..Action|s..  On |
|00000280| 50 72 6f 63 65 64 75 72 | 65 20 45 78 65 63 75 74 |Procedur|e Execut|
|00000290| 65 0d 0a 25 46 6f 72 45 | 61 63 68 43 68 69 6c 64 |e..%ForE|achChild|
|000002a0| 52 65 6c 28 29 20 7b 0d | 0a 20 20 25 52 65 6c 54 |Rel() {.|.  %RelT|
|000002b0| 65 6d 70 6c 61 74 65 0d | 0a 7d 0d 0a 25 46 6f 72 |emplate.|.}..%For|
|000002c0| 45 61 63 68 50 61 72 65 | 6e 74 52 65 6c 28 29 20 |EachPare|ntRel() |
|000002d0| 7b 0d 0a 20 20 25 52 65 | 6c 54 65 6d 70 6c 61 74 |{..  %Re|lTemplat|
|000002e0| 65 0d 0a 7d 0d 0a 29 20 | 25 53 63 6f 70 65 3b 0d |e..}..) |%Scope;.|
|000002f0| 0a 00 30 27             |                         |..0'    |        |
+--------+-------------------------+-------------------------+--------+--------+